SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [Live].[GetMostRecentSharedNAVDate] AS
BEGIN
SELECT MAX([e].[NAVDate]) NAVDate FROM  [FSFundModel].[Reporting].[Export] e 
GROUP BY [e].[ExportType]

HAVING [e].[ExportType] = 'NAV'
END

GO
